package com.pentofab.payrollmanagement.database.impl;

public interface SQLConstants {
	String comma = ", ";
	String select = "select ";
	String from = " from ";
	String where = " where ";
	String like = " like ?";
	String insert_into = "insert into ";
	String update = " update ";
	String delete = " delete ";
	String set = " set ";
	String values = " values ";
	String openingBrace = "(";
	String closingBrace = ")";
	String equals = "=";
	String question = " ? ";
	String space = " ";
	String and = " and ";
	String ORDEY_BY = " order by ";
	String LOWER = "lower";
	String convert = " Convert ";
	String decimal = "DECIMAL";
	String MINUS = "-";
	String sum = "sum";
	String ifNull = "IFNULL";
	String min = "MIN";
	String max = "MAX";
	String time = "TIME";
	String str2Date = "DATE_FORMAT(STR_TO_DATE";
	String join = "Join";
	String groupby = "GROUPBY";
	String as = " AS ";
	String on = " ON ";
	String greaterthanequals = ">=";
	String lessthanequals = "<=";
	String between = "BETWEEN";
	 String greaterthan = ">";
	 String lessthan = "<";
	 String timediff = "TIMEDIFF";
	 String sqldateformat = " '%e-%c-%Y'),'%d-%m-%Y'";
	 String sqlCurDate = "CURDATE()";
	 String CASE = " CASE ";
	 String WHEN = " WHEN ";
	 String OR= " OR ";
	 String then = " then ";
	 String ELSE = " ELSE ";
	 String END = " END ";
	 String singlequote = "'";
}
